﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AgileMaster.Database.Schema.SQLite
{
    public class SQLiteSchema : SchemaBase
    {
        protected override IEnumerable<string> GetCreateStatements()
        {
            string sql = LoadFromResource("WebUIMarkerWebServer.Database.Schema.Sqlite.Create.sql");
            return new string[] { sql };
        }

        protected override IEnumerable<string> GetDropStatements()
        {
            string sql = LoadFromResource("WebUIMarkerWebServer.Database.Schema.Sqlite.Drop.sql");
            return new string[] { sql };
        }

        protected override IEnumerable<string> GetUpgradeStatements()
        {
            string sql = LoadFromResource("WebUIMarkerWebServer.Database.Schema.Sqlite.Upgrade.sql");
            return new string[] { sql };
        }
    }
}
